Views [dbo].[Security_Group]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created3:38:08 PM Friday, January 07, 2011
Last Modified1:46:13 PM Thursday, September 22, 2011
Columns
Name
SecurityGroupCode
SecurityGroupName
Permissions
TypeActionOwning Principal
GrantSelectIMIS
SQL Script
CREATE      VIEW Security_Group
AS
  SELECT SECURITY_GROUP AS SecurityGroupCode, SECURITY_GROUP AS SecurityGroupName
    FROM Security_Groups
  UNION
  SELECT MEMBER_TYPE, DESCRIPTION + ' (Member Type)'
    FROM Member_Types
   WHERE MEMBER_TYPE NOT IN (SELECT SECURITY_GROUP FROM Security_Groups)

GO
GRANT SELECT ON  [dbo].[Security_Group] TO [IMIS]
GO
Uses